USE master;
GO
ALTER DATABASE tempdb 
MODIFY FILE (NAME = tempdev, FILENAME = 'L:\Database File\tempdb.mdf', size=120000MB, FILEGROWTH=100MB,MAXSIZE=UNLIMITED );
GO
ALTER DATABASE  tempdb 
MODIFY FILE (NAME = templog, FILENAME = 'I:\Database Logs\templog.ldf');
GO
/**
--tempdev
G:\Database File\tempdb.mdf
--templog
--G:\Database Logs\tempdb2005.ldf
tempdev_2
G:\Database File\tempdev_2.ndf
tempdev_3
G:\Database File\tempdev_3.ndf
temp4
K:\TempDB\temp4.ndf
TEMPDB1
L:\Database File\TEMPDB1.ndf






sp_helpfile

SELECT name, physical_name
FROM sys.master_files
WHERE database_id = DB_ID('tempdb');
GO
**/
